Chicago Sidewalk Cafe Permits

Dataset statistics

Number of variables	22
Number of observations	20119
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 MiB
Average record size in memory	176.0 B

Variable types

Numeric	10
Text	5
DateTime	3
Categorical	4

Alerts

`city` has constant value ""	Constant
`state` has constant value ""	Constant
`address_number_start` is highly overall correlated with `address_number` and 3 other fields	High correlation
`address_number` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`ward` is highly overall correlated with `police_district`	High correlation
`police_district` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`latitude` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`longitude` is highly overall correlated with `address_number_start` and 2 other fields	High correlation
`street_type` is highly imbalanced (52.2%)	Imbalance
`permit_number` has unique values	Unique
`address_number_start` has 1240 (6.2%) zeros	Zeros
`address_number` has 1240 (6.2%) zeros	Zeros

Reproduction

Analysis started	2023-12-06 14:21:18.841938
Analysis finished	2023-12-06 14:21:44.095879
Duration	25.25 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

permit_number
Real number (ℝ)

UNIQUE

Distinct	20119
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1154034.5

Minimum	1000571
Maximum	1862206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1000571
5-th percentile	1024842.4
Q1	1074664
median	1106727
Q3	1131949.5
95-th percentile	1648144.6
Maximum	1862206
Range	861635
Interquartile range (IQR)	57285.5

Descriptive statistics

Standard deviation	180318.84
Coefficient of variation (CV)	0.15625082
Kurtosis	5.2497972
Mean	1154034.5
Median Absolute Deviation (MAD)	25652
Skewness	2.5361042
Sum	2.3218021 × 10¹⁰
Variance	3.2514885 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1556602	1	< 0.1%
1086777	1	< 0.1%
1086803	1	< 0.1%
1086802	1	< 0.1%
1086799	1	< 0.1%
1086790	1	< 0.1%
1086788	1	< 0.1%
1086782	1	< 0.1%
1086779	1	< 0.1%
1086776	1	< 0.1%
Other values (20109)	20109	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000571	1	< 0.1%
1001307	1	< 0.1%
1002652	1	< 0.1%
1002993	1	< 0.1%
1003612	1	< 0.1%
1004393	1	< 0.1%
1007248	1	< 0.1%
1007265	1	< 0.1%
1007306	1	< 0.1%
1007406	1	< 0.1%

Value	Count	Frequency (%)
1862206	1	< 0.1%
1860048	1	< 0.1%
1855208	1	< 0.1%
1854101	1	< 0.1%
1852797	1	< 0.1%
1848630	1	< 0.1%
1848204	1	< 0.1%
1846561	1	< 0.1%
1845400	1	< 0.1%
1844680	1	< 0.1%

account_number
Real number (ℝ)

Distinct	3018
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	206000.21

Minimum	12
Maximum	495456
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	12
5-th percentile	5350
Q1	23077
median	254059
Q3	348425
95-th percentile	414151
Maximum	495456
Range	495444
Interquartile range (IQR)	325348

Descriptive statistics

Standard deviation	156290.49
Coefficient of variation (CV)	0.75869093
Kurtosis	-1.6003516
Mean	206000.21
Median Absolute Deviation (MAD)	144576
Skewness	-0.077377047
Sum	4.1445182 × 10⁹
Variance	2.4426717 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63414	886	4.4%
65004	312	1.6%
298727	114	0.6%
50161	85	0.4%
22633	66	0.3%
369504	64	0.3%
230211	61	0.3%
267891	48	0.2%
66022	45	0.2%
392906	44	0.2%
Other values (3008)	18394	91.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	6	< 0.1%
13	21	0.1%
16	4	< 0.1%
27	4	< 0.1%
28	11	0.1%
46	18	0.1%
51	6	< 0.1%
67	20	0.1%
73	17	0.1%
82	2	< 0.1%

Value	Count	Frequency (%)
495456	1	< 0.1%
494737	1	< 0.1%
494267	1	< 0.1%
493688	1	< 0.1%
493621	1	< 0.1%
493348	1	< 0.1%
493334	1	< 0.1%
493192	1	< 0.1%
493107	1	< 0.1%
493069	1	< 0.1%

site_number
Real number (ℝ)

Distinct	100
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3757642

Minimum	1
Maximum	230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	23
Maximum	230
Range	229
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	18.123494
Coefficient of variation (CV)	3.3713335
Kurtosis	41.246213
Mean	5.3757642
Median Absolute Deviation (MAD)	0
Skewness	5.9846541
Sum	108155
Variance	328.46104
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	14715	73.1%
2	2298	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
7	121	0.6%
6	106	0.5%
11	98	0.5%
12	94	0.5%
19	91	0.5%
Other values (90)	1491	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14715	73.1%
2	2298	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
6	106	0.5%
7	121	0.6%
8	65	0.3%
9	63	0.3%
10	67	0.3%

Value	Count	Frequency (%)
230	1	< 0.1%
229	1	< 0.1%
228	1	< 0.1%
226	1	< 0.1%
225	1	< 0.1%
224	1	< 0.1%
221	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%
211	2	< 0.1%

legal_name
Text

Distinct	3026
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	67
Median length	46
Mean length	21.099558
Min length	4

Characters and Unicode

Total characters	424502
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	681 ?
Unique (%)	3.4%

Sample

1st row	THE LIFEWAY KEFIR SHOP LLC
2nd row	SQUARE KITCHEN, LLC
3rd row	TEMPO CAFE LIMITED
4th row	The Funky Monkey Juice Bar
5th row	PLEASANT PIZZA, L.L.C.

Value	Count	Frequency (%)
inc	8857	12.9%
llc	6129	8.9%
corporation	1580	2.3%
restaurant	1297	1.9%
	1263	1.8%
starbucks	886	1.3%
chicago	882	1.3%
the	862	1.3%
corp	859	1.2%
cafe	705	1.0%
Other values (3621)	45494	66.1%

Most occurring characters

Value	Count	Frequency (%)
	48851	11.5%
C	30248	7.1%
I	29083	6.9%
A	28340	6.7%
N	27603	6.5%
L	26462	6.2%
O	25669	6.0%
R	25237	5.9%
E	24957	5.9%
T	20571	4.8%
Other values (68)	137481	32.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	333509	78.6%
Space Separator	48851	11.5%
Other Punctuation	26494	6.2%
Lowercase Letter	7885	1.9%
Decimal Number	6933	1.6%
Dash Punctuation	645	0.2%
Close Punctuation	85	< 0.1%
Open Punctuation	85	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	30248	9.1%
I	29083	8.7%
A	28340	8.5%
N	27603	8.3%
L	26462	7.9%
O	25669	7.7%
R	25237	7.6%
E	24957	7.5%
T	20571	6.2%
S	20236	6.1%
Other values (16)	75103	22.5%

Lowercase Letter

Value	Count	Frequency (%)
a	909	11.5%
e	905	11.5%
n	779	9.9%
o	653	8.3%
t	602	7.6%
r	591	7.5%
i	549	7.0%
s	513	6.5%
c	436	5.5%
l	353	4.5%
Other values (16)	1595	20.2%

Other Punctuation

Value	Count	Frequency (%)
.	11717	44.2%
,	11205	42.3%
'	2276	8.6%
&	1097	4.1%
#	92	0.3%
/	79	0.3%
"	18	0.1%
!	6	< 0.1%
@	2	< 0.1%
:	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	1325	19.1%
2	983	14.2%
0	893	12.9%
3	797	11.5%
5	796	11.5%
4	709	10.2%
8	466	6.7%
6	364	5.3%
7	356	5.1%
9	244	3.5%

Space Separator

Value	Count	Frequency (%)
	48851	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	645	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	85	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	85	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	341394	80.4%
Common	83108	19.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	30248	8.9%
I	29083	8.5%
A	28340	8.3%
N	27603	8.1%
L	26462	7.8%
O	25669	7.5%
R	25237	7.4%
E	24957	7.3%
T	20571	6.0%
S	20236	5.9%
Other values (42)	82988	24.3%

Common

Value	Count	Frequency (%)
	48851	58.8%
.	11717	14.1%
,	11205	13.5%
'	2276	2.7%
1	1325	1.6%
&	1097	1.3%
2	983	1.2%
0	893	1.1%
3	797	1.0%
5	796	1.0%
Other values (16)	3168	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	424502	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	48851	11.5%
C	30248	7.1%
I	29083	6.9%
A	28340	6.7%
N	27603	6.5%
L	26462	6.2%
O	25669	6.0%
R	25237	5.9%
E	24957	5.9%
T	20571	4.8%
Other values (68)	137481	32.4%

doing_business_as_name
Text

Distinct	3093
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	88
Median length	45
Mean length	16.847309
Min length	1

Characters and Unicode

Total characters	338951
Distinct characters	77
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	670 ?
Unique (%)	3.3%

Sample

1st row	LIFEWAY KEFIR SHOP
2nd row	FORK
3rd row	TEMPO CAFE
4th row	The Funky Monkey Juice Bar
5th row	BOB'S PIZZA

Value	Count	Frequency (%)
	2393	4.3%
cafe	1444	2.6%
the	1373	2.5%
coffee	1313	2.3%
restaurant	1269	2.3%
bar	1210	2.2%
grill	1046	1.9%
starbucks	904	1.6%
inc	729	1.3%
and	636	1.1%
Other values (3514)	43597	78.0%

Most occurring characters

Value	Count	Frequency (%)
	35922	10.6%
A	27911	8.2%
E	25851	7.6%
R	20137	5.9%
O	19837	5.9%
S	19389	5.7%
I	17488	5.2%
T	17398	5.1%
N	16778	4.9%
C	14863	4.4%
Other values (67)	123377	36.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	268064	79.1%
Space Separator	35922	10.6%
Lowercase Letter	18888	5.6%
Other Punctuation	9371	2.8%
Decimal Number	6183	1.8%
Dash Punctuation	477	0.1%
Math Symbol	42	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27911	10.4%
E	25851	9.6%
R	20137	7.5%
O	19837	7.4%
S	19389	7.2%
I	17488	6.5%
T	17398	6.5%
N	16778	6.3%
C	14863	5.5%
L	14452	5.4%
Other values (16)	73960	27.6%

Lowercase Letter

Value	Count	Frequency (%)
e	2391	12.7%
a	2308	12.2%
o	1514	8.0%
n	1499	7.9%
r	1377	7.3%
i	1364	7.2%
t	1155	6.1%
l	1110	5.9%
s	1080	5.7%
u	717	3.8%
Other values (15)	4373	23.2%

Other Punctuation

Value	Count	Frequency (%)
'	4092	43.7%
&	1842	19.7%
#	1296	13.8%
.	890	9.5%
,	579	6.2%
/	572	6.1%
"	46	0.5%
!	43	0.5%
@	8	0.1%
;	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1496	24.2%
1	936	15.1%
4	653	10.6%
3	600	9.7%
5	597	9.7%
0	569	9.2%
7	390	6.3%
6	361	5.8%
9	293	4.7%
8	288	4.7%

Space Separator

Value	Count	Frequency (%)
	35922	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	477	100.0%

Math Symbol

Value	Count	Frequency (%)
+	42	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	286952	84.7%
Common	51999	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27911	9.7%
E	25851	9.0%
R	20137	7.0%
O	19837	6.9%
S	19389	6.8%
I	17488	6.1%
T	17398	6.1%
N	16778	5.8%
C	14863	5.2%
L	14452	5.0%
Other values (41)	92848	32.4%

Common

Value	Count	Frequency (%)
	35922	69.1%
'	4092	7.9%
&	1842	3.5%
2	1496	2.9%
#	1296	2.5%
1	936	1.8%
.	890	1.7%
4	653	1.3%
3	600	1.2%
5	597	1.1%
Other values (16)	3675	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	338951	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	35922	10.6%
A	27911	8.2%
E	25851	7.6%
R	20137	5.9%
O	19837	5.9%
S	19389	5.7%
I	17488	5.2%
T	17398	5.1%
N	16778	4.9%
C	14863	4.4%
Other values (67)	123377	36.4%

issued_date
Date

Distinct	2999
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-12-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

expiration_date
Date

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-11-01 00:00:00
Maximum	2024-02-29 00:00:00

Histogram

Histogram with fixed size bins (bins=28)

payment_date
Date

Distinct	2947
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-11-16 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

address
Text

Distinct	2576
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	34
Median length	23
Mean length	16.682191
Min length	10

Characters and Unicode

Total characters	335629
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	447 ?
Unique (%)	2.2%

Sample

1st row	0 W DIVISION ST
2nd row	4600 N LINCOLN AVE
3rd row	6 E CHESTNUT ST
4th row	2152 W 95TH ST
5th row	1659 W 21ST ST

Value	Count	Frequency (%)
st	10462	12.9%
n	9115	11.2%
ave	8057	9.9%
w	7266	8.9%
e	1879	2.3%
s	1859	2.3%
0	1240	1.5%
clark	1189	1.5%
wells	1140	1.4%
lincoln	1043	1.3%
Other values (1882)	37936	46.7%

Most occurring characters

Value	Count	Frequency (%)
	61067	18.2%
E	21334	6.4%
S	21165	6.3%
A	20969	6.2%
N	20513	6.1%
T	16688	5.0%
1	12449	3.7%
L	12244	3.6%
I	11534	3.4%
W	11416	3.4%
Other values (26)	126250	37.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	206366	61.5%
Decimal Number	68196	20.3%
Space Separator	61067	18.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	21334	10.3%
S	21165	10.3%
A	20969	10.2%
N	20513	9.9%
T	16688	8.1%
L	12244	5.9%
I	11534	5.6%
W	11416	5.5%
R	10948	5.3%
O	10504	5.1%
Other values (15)	49051	23.8%

Decimal Number

Value	Count	Frequency (%)
1	12449	18.3%
0	10236	15.0%
2	8736	12.8%
3	8203	12.0%
5	7628	11.2%
4	6593	9.7%
6	4474	6.6%
7	4027	5.9%
8	3100	4.5%
9	2750	4.0%

Space Separator

Value	Count	Frequency (%)
	61067	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	206366	61.5%
Common	129263	38.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	21334	10.3%
S	21165	10.3%
A	20969	10.2%
N	20513	9.9%
T	16688	8.1%
L	12244	5.9%
I	11534	5.6%
W	11416	5.5%
R	10948	5.3%
O	10504	5.1%
Other values (15)	49051	23.8%

Common

Value	Count	Frequency (%)
	61067	47.2%
1	12449	9.6%
0	10236	7.9%
2	8736	6.8%
3	8203	6.3%
5	7628	5.9%
4	6593	5.1%
6	4474	3.5%
7	4027	3.1%
8	3100	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	335629	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	61067	18.2%
E	21334	6.4%
S	21165	6.3%
A	20969	6.2%
N	20513	6.1%
T	16688	5.0%
1	12449	3.7%
L	12244	3.6%
I	11534	3.4%
W	11416	3.4%
Other values (26)	126250	37.6%

address_number_start
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1641
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1663.9888

Minimum	0
Maximum	11208
Zeros	1240
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1236
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.2859
Coefficient of variation (CV)	0.97854382
Kurtosis	1.3926959
Mean	1663.9888
Median Absolute Deviation (MAD)	1034
Skewness	1.220358
Sum	33477790
Variance	2651315.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1240	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1631)	17999	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1240	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

address_number
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1641
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1663.9888

Minimum	0
Maximum	11208
Zeros	1240
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1236
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.2859
Coefficient of variation (CV)	0.97854382
Kurtosis	1.3926959
Mean	1663.9888
Median Absolute Deviation (MAD)	1034
Skewness	1.220358
Sum	33477790
Variance	2651315.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1240	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1631)	17999	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1240	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

street_direction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

N	9115
W	7266
E	1879
S	1859

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	20119
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	N
3rd row	E
4th row	W
5th row	W

Common Values

Value	Count	Frequency (%)
N	9115	45.3%
W	7266	36.1%
E	1879	9.3%
S	1859	9.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	9115	45.3%
w	7266	36.1%
e	1879	9.3%
s	1859	9.2%

Most occurring characters

Value	Count	Frequency (%)
N	9115	45.3%
W	7266	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	20119	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	9115	45.3%
W	7266	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20119	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	9115	45.3%
W	7266	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20119	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	9115	45.3%
W	7266	36.1%
E	1879	9.3%
S	1859	9.2%

street
Text

Distinct	228
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	24
Median length	13
Mean length	6.8897062
Min length	3

Characters and Unicode

Total characters	138614
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.1%

Sample

1st row	DIVISION
2nd row	LINCOLN
3rd row	CHESTNUT
4th row	95TH
5th row	21ST

Value	Count	Frequency (%)
clark	1189	5.7%
wells	1140	5.5%
lincoln	1043	5.0%
division	941	4.5%
michigan	729	3.5%
randolph	656	3.1%
southport	617	3.0%
milwaukee	599	2.9%
state	536	2.6%
halsted	500	2.4%
Other values (230)	12879	61.8%

Most occurring characters

Value	Count	Frequency (%)
A	12912	9.3%
L	11720	8.5%
I	11534	8.3%
E	11398	8.2%
N	11398	8.2%
O	10504	7.6%
R	10144	7.3%
S	8884	6.4%
T	6194	4.5%
D	6013	4.3%
Other values (25)	37913	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	136975	98.8%
Decimal Number	929	0.7%
Space Separator	710	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	12912	9.4%
L	11720	8.6%
I	11534	8.4%
E	11398	8.3%
N	11398	8.3%
O	10504	7.7%
R	10144	7.4%
S	8884	6.5%
T	6194	4.5%
D	6013	4.4%
Other values (15)	36274	26.5%

Decimal Number

Value	Count	Frequency (%)
3	312	33.6%
5	226	24.3%
1	143	15.4%
8	60	6.5%
6	56	6.0%
7	49	5.3%
2	44	4.7%
9	26	2.8%
4	13	1.4%

Space Separator

Value	Count	Frequency (%)
	710	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	136975	98.8%
Common	1639	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	12912	9.4%
L	11720	8.6%
I	11534	8.4%
E	11398	8.3%
N	11398	8.3%
O	10504	7.7%
R	10144	7.4%
S	8884	6.5%
T	6194	4.5%
D	6013	4.4%
Other values (15)	36274	26.5%

Common

Value	Count	Frequency (%)
	710	43.3%
3	312	19.0%
5	226	13.8%
1	143	8.7%
8	60	3.7%
6	56	3.4%
7	49	3.0%
2	44	2.7%
9	26	1.6%
4	13	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	138614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	12912	9.3%
L	11720	8.5%
I	11534	8.3%
E	11398	8.2%
N	11398	8.2%
O	10504	7.6%
R	10144	7.3%
S	8884	6.4%
T	6194	4.5%
D	6013	4.3%
Other values (25)	37913	27.4%

street_type
Categorical

IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

ST	10422
AVE	8057
RD	608
BLVD	269
PL	255
Other values (4)	508

Length

Max length	4
Median length	2
Mean length	2.4490283
Min length	2

Characters and Unicode

Total characters	49272
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ST
2nd row	AVE
3rd row	ST
4th row	ST
5th row	ST

Common Values

Value	Count	Frequency (%)
ST	10422	51.8%
AVE	8057	40.0%
RD	608	3.0%
BLVD	269	1.3%
PL	255	1.3%
PKWY	199	1.0%
DR	196	1.0%
CT	72	0.4%
HWY	41	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
st	10422	51.8%
ave	8057	40.0%
rd	608	3.0%
blvd	269	1.3%
pl	255	1.3%
pkwy	199	1.0%
dr	196	1.0%
ct	72	0.4%
hwy	41	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	10494	21.3%
S	10422	21.2%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49272	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10494	21.3%
S	10422	21.2%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49272	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10494	21.3%
S	10422	21.2%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49272	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10494	21.3%
S	10422	21.2%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

city
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

CHICAGO	20119

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	140833
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	20119	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	20119	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	40238	28.6%
H	20119	14.3%
I	20119	14.3%
A	20119	14.3%
G	20119	14.3%
O	20119	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140833	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	40238	28.6%
H	20119	14.3%
I	20119	14.3%
A	20119	14.3%
G	20119	14.3%
O	20119	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140833	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	40238	28.6%
H	20119	14.3%
I	20119	14.3%
A	20119	14.3%
G	20119	14.3%
O	20119	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140833	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	40238	28.6%
H	20119	14.3%
I	20119	14.3%
A	20119	14.3%
G	20119	14.3%
O	20119	14.3%

state
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

IL	20119

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	40238
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	20119	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	20119	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	20119	50.0%
L	20119	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	40238	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	20119	50.0%
L	20119	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40238	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	20119	50.0%
L	20119	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40238	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	20119	50.0%
L	20119	50.0%

zip_code
Real number (ℝ)

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60625.51

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	60601
5-th percentile	60602
Q1	60610
median	60618
Q3	60647
95-th percentile	60657
Maximum	60707
Range	106
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	19.888105
Coefficient of variation (CV)	0.00032804846
Kurtosis	-0.68202376
Mean	60625.51
Median Absolute Deviation (MAD)	11
Skewness	0.70050936
Sum	1.2197246 × 10⁹
Variance	395.53672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60611	1840	9.1%
60654	1768	8.8%
60622	1724	8.6%
60614	1550	7.7%
60657	1420	7.1%
60607	1157	5.8%
60613	981	4.9%
60610	949	4.7%
60647	883	4.4%
60618	835	4.2%
Other values (43)	7012	34.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60601	652	3.2%
60602	410	2.0%
60603	330	1.6%
60604	234	1.2%
60605	729	3.6%
60606	385	1.9%
60607	1157	5.8%
60608	207	1.0%
60609	31	0.2%
60610	949	4.7%

Value	Count	Frequency (%)
60707	47	0.2%
60661	504	2.5%
60660	199	1.0%
60659	189	0.9%
60657	1420	7.1%
60656	15	0.1%
60655	3	< 0.1%
60654	1768	8.8%
60653	20	0.1%
60651	3	< 0.1%

ward
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.48069

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	26
median	42
Q3	43
95-th percentile	47
Maximum	50
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	16.405511
Coefficient of variation (CV)	0.52112933
Kurtosis	-0.67684772
Mean	31.48069
Median Absolute Deviation (MAD)	5
Skewness	-0.95164101
Sum	633360
Variance	269.14078
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	5554	27.6%
1	1580	7.9%
27	1538	7.6%
47	1476	7.3%
44	1427	7.1%
2	1374	6.8%
43	1186	5.9%
32	1114	5.5%
4	666	3.3%
25	471	2.3%
Other values (34)	3733	18.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1580	7.9%
2	1374	6.8%
3	289	1.4%
4	666	3.3%
5	103	0.5%
6	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	13	0.1%
11	332	1.7%

Value	Count	Frequency (%)
50	104	0.5%
49	148	0.7%
48	361	1.8%
47	1476	7.3%
46	335	1.7%
45	238	1.2%
44	1427	7.1%
43	1186	5.9%
42	5554	27.6%
41	81	0.4%

police_district
Real number (ℝ)

HIGH CORRELATION

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.840897

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	12
median	18
Q3	19
95-th percentile	20
Maximum	25
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	6.866289
Coefficient of variation (CV)	0.49608701
Kurtosis	-0.40080436
Mean	13.840897
Median Absolute Deviation (MAD)	2
Skewness	-1.0015661
Sum	278465
Variance	47.145925
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
18	5339	26.5%
19	4255	21.1%
1	3656	18.2%
12	2388	11.9%
14	1788	8.9%
20	760	3.8%
16	418	2.1%
17	373	1.9%
24	309	1.5%
2	238	1.2%
Other values (13)	595	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	3656	18.2%
2	238	1.2%
3	10	< 0.1%
4	15	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	44	0.2%
9	223	1.1%

Value	Count	Frequency (%)
25	149	0.7%
24	309	1.5%
22	27	0.1%
20	760	3.8%
19	4255	21.1%
18	5339	26.5%
17	373	1.9%
16	418	2.1%
15	7	< 0.1%
14	1788	8.9%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2568
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.910369

Minimum	41.69067
Maximum	42.019421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	41.69067
5-th percentile	41.865345
Q1	41.885257
median	41.902442
Q3	41.93924
95-th percentile	41.978062
Maximum	42.019421
Range	0.32875146
Interquartile range (IQR)	0.053982374

Descriptive statistics

Standard deviation	0.037934124
Coefficient of variation (CV)	0.00090512503
Kurtosis	1.7963231
Mean	41.910369
Median Absolute Deviation (MAD)	0.020466559
Skewness	-0.10655293
Sum	843194.72
Variance	0.0014389978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88200199	98	0.5%
41.88197573	96	0.5%
41.90405052	86	0.4%
41.87801449	81	0.4%
41.88460018	69	0.3%
41.8825402	53	0.3%
41.89678605	40	0.2%
41.90186736	40	0.2%
41.87949547	37	0.2%
41.88216417	37	0.2%
Other values (2558)	19482	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.69066951	1	< 0.1%
41.69139989	2	< 0.1%
41.69245222	1	< 0.1%
41.69920305	10	< 0.1%
41.70289718	1	< 0.1%
41.70356373	2	< 0.1%
41.71874411	1	< 0.1%
41.72107515	10	< 0.1%
41.72112515	1	< 0.1%
41.72177014	1	< 0.1%

Value	Count	Frequency (%)
42.01942097	12	0.1%
42.0193885	5	< 0.1%
42.01934594	4	< 0.1%
42.01933013	3	< 0.1%
42.01932963	2	< 0.1%
42.0193098	4	< 0.1%
42.01927235	1	< 0.1%
42.0174068	8	< 0.1%
42.01615704	15	0.1%
42.01615267	15	0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2568
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.655297

Minimum	-87.834308
Maximum	-87.535139
Zeros	0
Zeros (%)	0.0%
Negative	20119
Negative (%)	100.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	-87.834308
5-th percentile	-87.709805
Q1	-87.672586
median	-87.648962
Q3	-87.629547
95-th percentile	-87.624225
Maximum	-87.535139
Range	0.29916895
Interquartile range (IQR)	0.043038819

Descriptive statistics

Standard deviation	0.033387503
Coefficient of variation (CV)	-0.00038089544
Kurtosis	5.1251329
Mean	-87.655297
Median Absolute Deviation (MAD)	0.020372619
Skewness	-1.7593019
Sum	-1763536.9
Variance	0.0011147254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.63103164	98	0.5%
-87.63397185	96	0.5%
-87.62874675	86	0.4%
-87.63318903	81	0.4%
-87.62798897	69	0.3%
-87.62453095	53	0.3%
-87.62828088	40	0.2%
-87.62849214	40	0.2%
-87.63382966	37	0.2%
-87.62451427	37	0.2%
Other values (2558)	19482	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.8343079	1	< 0.1%
-87.82625503	9	< 0.1%
-87.82618448	1	< 0.1%
-87.82167425	5	< 0.1%
-87.82042719	4	< 0.1%
-87.81865423	16	0.1%
-87.81795264	4	< 0.1%
-87.81783297	3	< 0.1%
-87.81729036	11	0.1%
-87.8172596	1	< 0.1%

Value	Count	Frequency (%)
-87.53513895	2	< 0.1%
-87.55117213	1	< 0.1%
-87.55124869	1	< 0.1%
-87.55161886	9	< 0.1%
-87.56729719	2	< 0.1%
-87.58184369	4	< 0.1%
-87.58390766	1	< 0.1%
-87.58502961	2	< 0.1%
-87.58781452	8	< 0.1%
-87.58797399	7	< 0.1%

location
Text

Distinct	2568
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	40
Median length	39
Mean length	39.105572
Min length	35

Characters and Unicode

Total characters	786765
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	446 ?
Unique (%)	2.2%

Sample

1st row	(41.90405051948726, -87.62874675447662)
2nd row	(41.964902360748326, -87.68627917084095)
3rd row	(41.89843137207629, -87.6280091630558)
4th row	(41.72112514525722, -87.67692855592173)
5th row	(41.853999857174315, -87.66845450091006)

Value	Count	Frequency (%)
41.88200198545344	98	0.2%
87.6310316367502	98	0.2%
41.881975727713886	96	0.2%
87.63397184627037	96	0.2%
41.90405051948726	86	0.2%
87.62874675447662	86	0.2%
41.878014487249544	81	0.2%
87.63318903001444	81	0.2%
87.62798896732363	69	0.2%
41.884600177780484	69	0.2%
Other values (5126)	39378	97.9%

Most occurring characters

Value	Count	Frequency (%)
8	84475	10.7%
4	75182	9.6%
7	74178	9.4%
6	72034	9.2%
1	70021	8.9%
9	62719	8.0%
2	53712	6.8%
3	53210	6.8%
5	52653	6.7%
0	47748	6.1%
Other values (6)	140833	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	645932	82.1%
Other Punctuation	60357	7.7%
Open Punctuation	20119	2.6%
Space Separator	20119	2.6%
Dash Punctuation	20119	2.6%
Close Punctuation	20119	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	84475	13.1%
4	75182	11.6%
7	74178	11.5%
6	72034	11.2%
1	70021	10.8%
9	62719	9.7%
2	53712	8.3%
3	53210	8.2%
5	52653	8.2%
0	47748	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	40238	66.7%
,	20119	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	20119	100.0%

Space Separator

Value	Count	Frequency (%)
	20119	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	20119	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	20119	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	786765	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	84475	10.7%
4	75182	9.6%
7	74178	9.4%
6	72034	9.2%
1	70021	8.9%
9	62719	8.0%
2	53712	6.8%
3	53210	6.8%
5	52653	6.7%
0	47748	6.1%
Other values (6)	140833	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	786765	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	84475	10.7%
4	75182	9.6%
7	74178	9.4%
6	72034	9.2%
1	70021	8.9%
9	62719	8.0%
2	53712	6.8%
3	53210	6.8%
5	52653	6.7%
0	47748	6.1%
Other values (6)	140833	17.9%

Auto

Heatmap
Table

	permit_number	account_number	site_number	address_number_start	address_number	zip_code	ward	police_district	latitude	longitude	street_direction	street_type
permit_number	1.000	0.473	0.017	-0.174	-0.174	-0.018	-0.082	-0.156	-0.143	0.039	0.037	0.041
account_number	0.473	1.000	-0.174	-0.123	-0.123	-0.046	-0.108	-0.158	-0.136	0.021	0.075	0.067
site_number	0.017	-0.174	1.000	-0.122	-0.122	-0.097	0.075	-0.051	-0.074	0.144	0.069	0.054
address_number_start	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.745	0.294	0.210
address_number	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.745	0.294	0.210
zip_code	-0.018	-0.046	-0.097	0.378	0.378	1.000	0.177	0.452	0.450	-0.476	0.307	0.222
ward	-0.082	-0.108	0.075	0.176	0.176	0.177	1.000	0.510	0.453	-0.049	0.286	0.167
police_district	-0.156	-0.158	-0.051	0.513	0.513	0.452	0.510	1.000	0.813	-0.339	0.383	0.186
latitude	-0.143	-0.136	-0.074	0.707	0.707	0.450	0.453	0.813	1.000	-0.633	0.385	0.212
longitude	0.039	0.021	0.144	-0.745	-0.745	-0.476	-0.049	-0.339	-0.633	1.000	0.321	0.268
street_direction	0.037	0.075	0.069	0.294	0.294	0.307	0.286	0.383	0.385	0.321	1.000	0.241
street_type	0.041	0.067	0.054	0.210	0.210	0.222	0.167	0.186	0.212	0.268	0.241	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
0	1556602	328992	1	THE LIFEWAY KEFIR SHOP LLC	LIFEWAY KEFIR SHOP	07/16/2021	02/28/2022	07/16/2021	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	1	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
1	1534556	252742	1	SQUARE KITCHEN, LLC	FORK	07/16/2021	02/28/2022	07/16/2021	4600 N LINCOLN AVE	4600	4600	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.964902	-87.686279	(41.964902360748326, -87.68627917084095)
2	1540360	23957	1	TEMPO CAFE LIMITED	TEMPO CAFE	07/16/2021	02/28/2022	07/15/2021	6 E CHESTNUT ST	6	6	E	CHESTNUT	ST	CHICAGO	IL	60611.0	2	18.0	41.898431	-87.628009	(41.89843137207629, -87.6280091630558)
3	1549937	475175	1	The Funky Monkey Juice Bar	The Funky Monkey Juice Bar	07/22/2021	02/28/2022	07/22/2021	2152 W 95TH ST	2152	2152	W	95TH	ST	CHICAGO	IL	60643.0	19	22.0	41.721125	-87.676929	(41.72112514525722, -87.67692855592173)
4	1531318	431422	1	PLEASANT PIZZA, L.L.C.	BOB'S PIZZA	07/23/2021	02/28/2022	07/23/2021	1659 W 21ST ST	1659	1659	W	21ST	ST	CHICAGO	IL	60608.0	25	12.0	41.854000	-87.668455	(41.853999857174315, -87.66845450091006)
5	1538898	317383	1	AJD RESTAURANT GROUP, LLC	SULLY'S HOUSE	07/23/2021	02/28/2022	07/22/2021	1501 N DAYTON ST	1501	1501	N	DAYTON	ST	CHICAGO	IL	60642.0	2	18.0	41.908620	-87.649295	(41.90861972732258, -87.64929457094323)
6	1548849	211324	1	ITALIAN RISTORANTE-HUBBARD, LLC	VERMILION	12/18/2021	02/28/2022	12/18/2021	10 W HUBBARD ST	10	10	W	HUBBARD	ST	CHICAGO	IL	60654.0	42	18.0	41.890169	-87.628394	(41.89016858549094, -87.62839433601951)
7	1540948	18039	1	SAVBET, INC.	BOURBON CAFE'	12/14/2021	02/28/2022	06/07/2021	4768 N LINCOLN AVE	4768	4768	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.968309	-87.688536	(41.968308771943036, -87.68853600406185)
8	1558131	303392	1	MCM PUB & LIQUOR, INC.	MCM PUB AND LIQUORS	01/11/2022	02/28/2022	01/11/2022	0 N CICERO AVE	0	0	N	CICERO	AVE	CHICAGO	IL	60641.0	45	15.0	41.880561	-87.745427	(41.880560880394704, -87.74542684331763)
9	1643969	463188	1	ETTA RIVER NORTH, LLC	ETTA	03/09/2022	02/28/2023	02/24/2022	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	2	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
20109	1837429	405088	2	ROTI RESTAURANTS, LLC	ROTI MODERN MEDITERRANEAN	07/18/2023	02/29/2024	07/18/2023	80 E LAKE ST	80	80	E	LAKE	ST	CHICAGO	IL	60601.0	42	1.0	41.885847	-87.625095	(41.885847208704554, -87.62509485736301)
20110	1680974	27127	1	LOUIE'S PUB, INC.	LOUIE'S PUB	07/18/2023	02/28/2023	07/18/2023	0 W NORTH AVE	0	0	W	NORTH	AVE	CHICAGO	IL	60622.0	2	18.0	41.911332	-87.628955	(41.911331719638085, -87.6289547607781)
20111	1808276	381123	1	720 SUSHI MIKE's LLC	TANOSHII SUSHI MIKE'S	07/19/2023	02/29/2024	05/18/2023	720 W RANDOLPH ST	720	720	W	RANDOLPH	ST	CHICAGO	IL	60661.0	27	12.0	41.884523	-87.646521	(41.88452285187888, -87.64652058438048)
20112	1797513	322099	1	1721 W. DIVISION CORP.	Mama Delia & Bordel	07/19/2023	02/29/2024	07/19/2023	1721 W DIVISION ST	1721	1721	W	DIVISION	ST	CHICAGO	IL	60622.0	1	12.0	41.903181	-87.670876	(41.903180986329666, -87.67087633768513)
20113	1838027	415210	1	AREPA GEORGE LP	AREPA GEORGE	07/24/2023	02/29/2024	07/24/2023	0 N KEDZIE AVE	0	0	N	KEDZIE	AVE	CHICAGO	IL	60651.0	26	11.0	41.881016	-87.706271	(41.881015948678254, -87.7062708302215)
20114	1779609	393307	1	ALULU LLC	ALULU	07/25/2023	02/29/2024	07/25/2023	0 S LAFLIN ST	0	0	S	LAFLIN	ST	CHICAGO	IL	60608.0	25	12.0	41.881448	-87.664564	(41.8814479951026, -87.6645642415278)
20115	1824848	491975	1	DIVISION BAR AND RESTAURANT LLC	Desert Hawk	07/26/2023	02/29/2024	07/26/2023	2049 W DIVISION ST	2049	2049	W	DIVISION	ST	CHICAGO	IL	60622.0	1	12.0	41.903046	-87.679195	(41.903045577773014, -87.67919511353082)
20116	1807568	494267	1	NESH MEDITERRANEAN GRILL LLC	NESH MEDITERRANEAN GRILL	07/26/2023	02/29/2024	07/26/2023	205 W MONROE ST	205	205	W	MONROE	ST	CHICAGO	IL	60606.0	42	1.0	41.880548	-87.633981	(41.880547897806615, -87.63398066695044)
20117	1805009	21010	1	KITSCH'N ON ROSCOE, INC.	KITSCH'N ON ROSCOE	07/28/2023	02/29/2024	07/28/2023	2005 W ROSCOE ST	2005	2005	W	ROSCOE	ST	CHICAGO	IL	60618.0	32	19.0	41.943105	-87.678679	(41.94310456354472, -87.67867885196078)
20118	1783094	424543	2	1253 W 18TH STREET, LLC	Sushi Hoshi	07/28/2023	02/29/2024	07/28/2023	0 S LAFLIN ST	0	0	S	LAFLIN	ST	CHICAGO	IL	60608.0	25	12.0	41.881448	-87.664564	(41.8814479951026, -87.6645642415278)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values